Supported target data types

The following table shows the default mapping from Qlik Replicate data types to Microsoft Azure Event Hubs data types.

For information on source data type mappings, see the section for the source endpoint you are using.

For additional information about Qlik Replicate data types, see Replicate data types.

When using the JSON message format, binary values are represented as hexadecimal digits.

Qlik Replicate and Microsoft Azure Event Hubs data types
Qlik Replicate Data Types	Microsoft Azure Event Hubs Target Data Types in Schema Messages
DATE	DATE
TIME	TIME
DATETIME	DATETIME
BYTES	BYTES (length)
BLOB	BLOB
REAL4	REAL4 (7)
REAL8	REAL8 (14)
INT1	INT1 (3)
INT2	INT2 (5)
INT4	INT4 (10)
INT8	INT8 (19)
UINT1	UINT1 (3)
UINT2	UINT2 (5)
UINT4 Information note Values larger than 2^31-1 are not supported.	UINT4 (10)
UINT8 Information note Values larger than 2^63-1 are not supported.	UINT8 (20)
NUMERIC	NUMERIC (p,s)
STRING	STRING (Length)
WSTRING	STRING (Length)
CLOB	CLOB
NCLOB	NCLOB
BOOLEAN	BOOLEAN (1)

Mapping to JSON and Avro

Avro message format uses logical types for a more precise representation of the data type.

Data type mappings
Qlik Replicate Data Types	JSON or Avro Primitive Data Types	Avro Logical Data Types
DATE	STRING	DATE Annotates an Avro INT.
TIME	STRING	TIME-MILLIS Annotates an Avro INT.
TIMESTAMP	STRING	TIMESTAMP-MICROS Annotates an Avro LONG.
STRING	STRING	-
WSTRING	STRING	-
CLOB	STRING	-
NCLOB	STRING	-
NUMERIC	STRING	DECIMAL (p,s) Annotates an Avro BYTES.
BYTES	BYTES	-
BLOB	BYTES	-
REAL4	FLOAT	-
REAL8	DOUBLE	-
INT1	INT	-
INT2	INT	-
INT4	INT	-
UINT1	INT	-
UINT2	INT	-
UINT4	LONG	-
INT8	LONG	-
UINT8	STRING	DECIMAL (20,0) Annotates an Avro BYTES.
BOOLEAN	BOOLEAN	-

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!